4175 N Van Ness Boulevard N
Fresno, CA 93704 • 7 Bed • 7 Bath • 6,734 sq.ft.

Property summary

This 1928 Sunset Boulevard Mediterranean Revival residence, situated on a 1.76 acre lot on Christmas Tree Lane in Old Fig Garden, was designed by renowned architect Rafael Lake for the Bernhauer family. As President of the then Fresno Planing Mill Co., Mr. Bernhauer infused his vision and craftsmanship into every detail of this home, which includes Mahogany millwork archways, coffered ceilings and so much more. As you enter thru the Arch Top Mahogany Double Doors, you are greeted by a Grand Foyer and a beautiful curved staircase. To the right is the Spacious Formal Living Room offering a stunning Fireplace, an adjacent elevated sitting space, and to complete this wing of the home, an Isolated Bedroom w/En-Suite Bath. To the left of the Foyer is the grand Formal Dining Room, boasting a Curved Bay Window that floods the room with natural light and can accommodate a large gathering of family and friends. Two Butler Pantries, both with sinks and an abundance of counter space, expand on the spacious Kitchen space for entertaining. A second staircase to the upstairs is situated between the two Butler Pantries, as well as the stairs to the basement which boasts a beautiful Wine Room. The Chef's Kitchen features Exquisite Portuguese Tiles, Wolf Range, Wall Oven, Built-in Refrigerator, Built-in Griddle, Informal Dining Area, and a Pantry. A lovely Studio/Family room is located adjacent to the Kitchen and offers a Fireplace and a wall of Shuttered Windows, which makes it a perfect room for relaxation. The over-sized Laundry Room featuring a Sink, ample Counter Space, Washer/Dryer and a Freezer, plus another Spacious Isolated Bedroom with adjacent Bath complete this section of the home. The Upstairs features the Primary Bedroom with an En-suite Bath, Dressing Area, walk-in Closet and access to a Balcony which views the rear garden. Bedroom # 4 views the front garden, Bedroom #5 features an En-Suite Bath, and Bedroom #6 and #7 which share a Jack-n-Jill Bath complete the Upstairs The Guest House is just steps away from the house and features a Spacious Bedroom, Kitchen with Dining Area, a Shower Bath, plus a storage room, and offers views of the Sparkling Swimming Pool and beautiful Grounds. Other Amenities include a 4+ Car Garage, Tile Roof, on most of the home, Owned Solar, 4 HVAC Units, Potential RV Parking. Completely Fenced Property offering Mature Landscaping. Do not miss the opportunity to make this special property your new home! Call for your private showing.

Days on market: 1

Listing updated: September 28, 2025 - 01:23:09

Property details

Property ID
FR25227017
Size
6734 sq.ft.
Home Type
Residential
Year Built
1928
Property Size
1.76 acres
Garage
4
Levels
2
Spa
No
Patio
Concrete
Basement
1
View
None
Pool
Private

Listed by: Angie Hyatt DRE #01013098 559-229-9961, Hyatt Real Estate - Fresno

Source: Fresno, MLS#: FR163 Originating MLS: CRMLS

Interior information

Rooms
Bathroom, Bedroom, Family Room, Foyer, Kitchen, Laundry, Living Room, Primary Bedroom, Pantry
Bathrooms
7
Kitchen
Built-In Range, Dishwasher, Electric Oven, Freezer, Disposal, Refrigerator, Dryer, Washer
Cooling
Central Air, Wall/Window Unit(s)
Heating
Central
Flooring
N/A
Laundry
Laundry Room
$2,350,000
Property price
Make an offer
Savings estimator
Revesty savings: $81K
Calculate your
savings
Mortgage estimator
Est.: $9,400/mo
Calculate monthly
payments
Have questions about this property?
Working hours: Monday to Friday 9:00am - 6:00pm (PST)

More Properties

3909 Reche Rd 191
Fallbrook, CA 92028
$195,000
2 Bed • 2 Bath • 840 sq.ft.
View details
5004 Star Mine Way
Antioch, CA 94531
$850,000
5 Bed • 3 Bath • 3,131 sq.ft.
View details
384 S 11th Street
San Jose, CA 95112
$598,000
2 Bed • 3 Bath • 1,050 sq.ft.
View details
CRMLS logo

The multiple listing data appearing on this website, or contained in reports produced therefrom, is owned and copyrighted by California Regional Multiple Listing Service, Inc. ("CRMLS") and is protected by all applicable copyright laws. Information provided is for viewer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties the viewer may be interested in purchasing. All listing data, including but not limited to square footage and lot size is believed to be accurate, but the listing Agent, listing Broker and CRMLS and its affiliates do not warrant or guarantee such accuracy. The viewer should independently verify the listed data prior to making any decisions based on such information by personal inspection and/or contacting a real estate professional. Based on information from California Regional Multiple Listing Service, Inc. as of 2025-09-29 20:24:05 PST and /or other sources. All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.

Get your home valuation estimate

REVESTY estimates are powered by MLS data, the most accurate and reliable source in the industry. Enter your address and get a precise home value estimate from a REVESTY agent.

clock icon

We will contact you within 3 hours.

Thank you for your patience.